Connect Using ODBC Connection In Vbscript

I am trying to connect to a database and run a query using vbscript. The problem I have run into currently is that I can not get the connection to open even though I know the DSN name it still says it can not find it. I am fairly new to vbscript so I am not sure exactly what it is looking for in the connection string so that it will find the database. Any ideas?

View Replies


ADVERTISEMENT

Cannot Connect To SQL 2005 Using System DSN ODBC Connection

 

I am running SQL 2005 SP1 on Win 2003 Std x64 SP2. I get an error trying to connect using an ODBC System DSN connection. The ODBC connection gets the following error:
 

Connection failed:
SQLState:'28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'
 
The SQL Server logs the following error:
 
18456, Severity: 14, State: 8.
 
I have tried this with several SQL accounts. I am able to login to the SQL Manager with the accounts without issue. It is only when trying to connect via ODBC that I get the error. I am currently downloading SQL 2005 SP2 to see if this will help with the issue. Any other ideas would be greatly appreciated.
 
Thanks.
 
John

View Replies View Related

Automating ODBC Changes For Multiple Users; Vbscript?

Hi,

I need to change over 500 client ODBC connections as I am migrating a SQL 2000 database to a cluster and microsoft doesn't support renaming SQL clusters.

I have a vbscript (below) which allows me to setup the appropriate ODBC connection but it doesn't allow me to specifiy using mixed mode sql authentication and subsequently a password for that account (though it does insert the username).

Is there any way to do this?! If not is there a better way to automate mutiple odbc changes?

If I can't figure out a way to do this I'm going to have to go round to every client manually as this migration has to happen in a week! :eek:

Any help greatfully appriciated!

Scrpit:

Option Explicit
'Constants
Const HKEY_CLASSES_ROOT = &H80000000
Const HKEY_CURRENT_USER = &H80000001
Const HKEY_LOCAL_MACHINE = &H80000002
Const HKEY_USERS = &H80000003
Const HKEY_CURRENT_CONFIG = &H80000005

'Variables
On Error Resume Next
Dim DataSourceName
Dim DatabaseName
Dim Description
Dim DriverPath
Dim LastUser
Dim Server
Dim Trusted_connection
Dim DriverName
Dim InputFile
Dim iFSO
Dim ifile
Dim sComputer
Dim sPath

'Value assignment

DataSourceName = "ODBCname"
DatabaseName = "Database"
DriverPath = "C:WINNTSystem32sqlsrv32.dll"
LastUser = "username"
Server = "servername"
Trusted_connection = "Yes"
Description = "Connection_description"
DriverName = "SQL Server"
InputFile = "c:pclist.txt"
Set iFSO = CreateObject("Scripting.FilesyStemObject")
Set ifile = iFSO.OpenTextFile(InputFile)
sPath = "SOFTWAREODBCODBC.INI" & DataSourceName

'Read and loop through the input file
Do Until ifile.AtEndOfLine
sComputer = ifile.ReadLine
If (0 = CreateRegKey(sComputer, HKEY_LOCAL_MACHINE, sPath)) Then
SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Database", DatabaseName
SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Description", Description
SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Driver", DriverPath
SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "LastUser", LastUser
SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Server", Server
SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Trusted_Connection", Trusted_connection
Else
Exit Do
End If

'Write in "ODBC Data Sources" Key to allow ODBC Manager list & manage the new DSN
SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, "SOFTWAREODBCODBC.INIODBC Data Sources", DataSourceName, DriverName
MsgBox (sComputer & " DONE!")
Loop
ifile.Close
Set ifile = Nothing


'Create RegKey Function

Function CreateRegKey(sComputer, hTree, sKey)
Dim oRegistry
Dim lResult
Set oRegistry = GetObject("winmgmts:{impersonationLevel=impersonate}//" & sComputer & "/root/default:StdRegProv")
lResult = oRegistry.CreateKey(hTree, sPath)
If (lResult = 0) And (Err.Number = 0) Then
CreateRegKey = 0
Else
CreateRegKey = 1
MsgBox ("Create Key " & sKey & " Failed")
End If
Set oRegistry = Nothing
End Function

'set RegKey Function

Function SetRegKeyStrValue(sComputer, hTree, sKey, sValueName, sValue)
Dim oRegistry
Dim lResult
Set oRegistry = GetObject("winmgmts:{impersonationLevel=impersonate}//" & sComputer & "/root/default:StdRegProv")
lResult = oRegistry.SetStringValue(hTree, sKey, sValueName, sValue)
If (lResult = 0) And (Err.Number = 0) Then
SetRegKeyStrValue = 0
Else
SetRegKeyStrValue = 1
MsgBox ("Set Value for " & sKey & " Failed")
End If
Set oRegistry = Nothing
End Function

View Replies View Related

Unable To Connect MS SQL Server Thru Vbscript In ASP

Hi All

I'm new to ASP coding and trying to connect to SQL server in ASP thru vbscript.
It works fine in the local machine, but received the "[DBNETLIB][connectionopen[connect().]SQL server does not exist or access denied" in the client machine, can anybody help to sort this out?

connection string

conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=clnt_user;Password=welcome;Initial Catalog=attendance;Data Source=(local)"

Thanks,
nags.

View Replies View Related

Question On VBScript Connection Issue And SQL 2005

I have a script that performs a number of reiterative tasks very quickly on a SQL database. After a few thousand requests (2-3 minutes) I get the following error:

Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Code: 80004005
Source: Microsoft OLE DB Provider for ODBC Drivers

The connection string looks like:

Driver={SQL Server};Server=45.22.11.33;Uid=test;Pwd=test;Database=Test

I have changed nothing and it always does this. It doesn't matter if in my script I open and close the connection on every request or leave it open the whole time.

Additionally, the script and the database are on the same machine.

Thanks for any help.

View Replies View Related

Question On VBScript Connection Issue And SQL 2005

I have a script that performs a number of reiterative tasks very quickly on a SQL database. After a few thousand requests (2-3 minutes) I get the following error:

Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Code: 80004005
Source: Microsoft OLE DB Provider for ODBC Drivers

The connection string looks like:

Driver={SQL Server};Server=45.22.11.33;Uid=test;Pwd=test;Database=Test

I have changed nothing and it always does this. It doesn't matter if in my script I open and close the connection on every request or leave it open the whole time.

Additionally, the script and the database are on the same machine.

Thanks for any help.

View Replies View Related

Can't Find SQL Native Client In ODBC Connection Manager In SQL Server Open Database Connectivity (ODBC)

I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.

I am running Windows XP Pro SP2. I have installed the SQL Native Client for 
XP. However, when I try to add a new data source through ODBC Connection 
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?

View Replies View Related

Remote Connection Refused When Creating ODBC Connection To SQL Server 2005

When I create a new odbc connection to a SQL server 2005 Db I get a failure telling me dat de SQL server does not allow remote connections.

How can I allow the server to allow this.

 

Any help appreciated

 

regards

View Replies View Related

Lost Connection To MySQL During Query In My ODBC Connection

I am trying to connect Visual Studio 2005 here in the Philippines to a MySQL server in CA, USA using the Connector/ODBC using the following parameters:

 

DSN = mysqlodbc

Server = host376.ipowerweb.com

userid = myuid

password = mypassword

 

when i used the port 3036  i got the  can't connect to MySQL on server blabla(10060)

 

when i used the port 8087 i got the "Lost connection to MySQL during query.

 

How do i connect successfully?

 

 

 

 

View Replies View Related

The TCP/IP Connection To The Host Has Failed. Java.net.ConnectException: Connection Timed Out: Connect

Hi,
                i am getting this exception i.e."

The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect" whenever i try to connect to the remote DB which is present at a different system.

View Replies View Related

Cannot Connect With ODBC Using TCP/IP??

Win 2003 Small business server with IIS being used as a web server.
Our client app can log in and run queries, but our web app when trying to log in gets the message,
'SQL server does not exsist or access denied'
The system DSN's are both sql drivers and the configuration is name pipes. Our recomended specs use TCP/IP, but when I try to change it, it craps out on me. He's opened up his firewall completely to this new box and his old box, a Win2k machine can connect using TCP/IP. This machine is in a work group.
Any suggestions on what it might be??? :confused:

View Replies View Related

Connect Via Odbc

i have an sql express db on my webserver.
now from another computer I am trying to creat an odbc connection to the sql server but when I enter in just the ip and the login and password it fails.
Please advise me what I can do?

what i really am trying to do is set up an access db on my home computer to be linked to an sql server express backend.
I thought to do this with odbc - is this the correct way?

View Replies View Related

How To Connect Via ODBC

Hi,

 I would like to connect in SqlServer 2005 via ODBC SQLServer, how are the steps?

 1 - How can I connect ODBC?

     1.1 -  I need SqlServer 2005 name - ok

     1.2 - Which option should I take in order to login? Windows NT authentication or Sql Server authentication?

Which one is the best option?

 

Cheers,

Alessandro

View Replies View Related

Connect From ASP To SQL Server Through ODBC

Hi there,

I'm a new comer to this APS language and hope sombody out there can help me with this
I'm trying to find codes for me to connect from ASP to Sql Server using ODBC.
Can anyone help me
Thanx

View Replies View Related

Connect By ODBC From Script To Db

Hi!

I want to connect to a SQL Server database on another server by ODBC from a T-SQL script. Does anyone know the syntax to connect ?

//Larsson

View Replies View Related

I Can't Connect To Server Through ODBC....

Hi all
I have problem with making Connection between two computer through SQLServer and ODBC.

I have two computers which are members of a WorkGroup network with WindowsXP(sp2) installed.
on one computer i have installed SQL Server 2000 Enterprise edition with MIX Authentication mode enabled. Also i have created a LOGIN (Sql Server Authentication) with System Administrator ROLE (SYSADMIN).in that sql server environment .

But in another computer when i want to create an ODBC connection (ControlPanelAdministrative ToolsData Sources (ODBC)) to connect to mentioned Computer with Sql server,I receive the following Error:
Access Denied...Sql Server doesn't exist.

I have disabled Windows-XP firewall on both computers but still problem persists.
By the way these two computer have one Administrator Account with DEFFERENT Passwords.

Could anyone help me.? Any help greately would be appreciated.

Kind Regards.

View Replies View Related

Connect To ODBC Driver

Could someone tell me how to use a query with a "connection string" to connect to an ODBC driver and retrieve data from its tables. I am new at this and have been having a lot of trouble connecting from the SSIS manager. If someone has a tutorial on how to do this. I would really appreciate it.

Thanks

View Replies View Related

Connect To MSSQL2005 Via ODBC

Installed SQL2005, connect via (the new) SQL Nativ Client ODBC Vers. 2005.90.1399.00 works, just as (the old) SQL Server ODBC-Driver 2000.85.1117.00. Works fine.

View Replies View Related

ODBC Connect Failed In SQL Job

I am running SQL Server 2000 sp4 in Win Server 2003. I have a DTS
packages which connects to FileMaker 6 files via the ODBC driver
installed with FielMaker.

The DTS packages work correctly when
executed directly. However, when executed from a SQL Server Agent job,
the same DTS packages fail. Always with the same message:

    Error:  -2147467259 (80004005);
    Provider Error:  16394 (400A)     
    Error string:  [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed     
    Error source:  Microsoft OLE DB Provider for ODBC Drivers


Searching
for info on the above message seems to indicate a permissions problem.
However, I am running the jobs with an full administrator account. All
connections and the FielMaker files reside on the one server.

Any help on this would be greatly appreciated.

Thank you.

View Replies View Related

Using ODBC To Connect To SQL Server Database

I am trying out a simple ASP.NET application which includes access to an SQL Server Database. It works fine on my local machine when I connect to the SQL Server and use SQL commands (via C#) to access it.
But my web hosting provider uses ODBC drivers for database access (they support the SQL database type). I would like to find out how I should connect to my SQL Server database and program the access in order for it to be ODBC compatible, so that I can deploy it to my web hosting server.  I should also mention that I am using Visual Web Developer 2005 Express Edition.
Thanks for any help or pointers.
Kumar

View Replies View Related

Connect To SqlServer 2005 With Odbc

Hi all,
I'm not a db guru and probably this is a very simple question for you, but I was wondering if it was possible to connect to a SqlServer using odbc without DSN.
I mean, I'm trying to connect to the db server from a linux (Fedora Core 8) workstation, using odbc drivers, but it looks like I can do that only using a DSN connection and setting properly the odbc.ini file. It doesn't work, if I use a connection like this from a PHP script:
$cn = odbc_connect("Driver={SQL Server};Server=MyServer;Database=MyDatabase",
"MyUser","MyPassword")
Does anyone know how to connect to SqlServer with a DSN-less connection? Could you explain me where is the error?

I'm using SQLServer2005, Fedora Core 8 with the last FreeTDS installed.

Please help!

Thanks million in advance.

View Replies View Related

Win32::ODBC Connect To MSSQL

Hi,

I wanted to know if there is a way to connect to my MSSQL without having to setup a datasource in the control panel.

Perferably I want to locate the database within my perl code instead. I don't want to have to setup a datasource each time I need a different database. Perhaps there is a way to pass the name of the database along with the username and password through the command line.


Any suggestions?

Thanks.

View Replies View Related

Cannot Connect Using ODBC Or OLEDB Provider

HI, I installed SQL Server 2005 as a named instance. While I can connect to my server using SQLCMD or SSMS, SSIS; I cannot create a DSN entry that can connect to it, use OLEDB or connect using OSQL. I get the following message when I try to connect to the server using these technologies:

"Cannot generate SSPI context"

I also have a SQL Server 2000 named instance on my PC and I do not have these kind of problems (connecting using ODBC, OLEDB or OSQL).

Is there a configuration setting that I am missing?

Thank you,

Ccote

View Replies View Related

ODBC Tries To Connect Through The Wrong Port

Hi,

 

I've been running some tests with a 3rd party application during the last few days, but the ODBC doesn´t seem to be working well.

 

The ODBCs are configured to go through specific ports, since there's a firewall between the server (production area) and the database (which is located in the dev area). If i press the TEST CONFIGURATION button after i configured the ODBCs, the test is successful, and the log file of the firewall monitor shows that the server is connecting through the designated ports.

 

But when i run the 3rd party application, the queries fail, showing an error that says "The server cannot be found or you don´t have access", after this error, another one appears, saying something like "Connection().opened..." - unfortunately I don't have the actual text, I'll try to post it as soon as i get them .

 

Just to make sure that the 3rd party app is doing its job, dev team wrote a simple VB6 app to query the database, and it shows the same error.

 

Both apps are running well in the dev environment, since dev machines don't have to go through the firewall, and both apps are using the ODBC configured in the same way as the server. I could think that the problem is the firewall, but the firewall logs show that the production server is trying to use ports 1433, 1434, 445 and 139, and there isn´t a single entry showing activity for the ports specified on the ODBCs configuration.

 

 

 

The database server is running SQL Server 2000, the dev pcs are running Windows 2000, and the ODBC driver version is 2000.85.1117.00.

 

On the Production environment the server that is trying to access the database is running Windows 2003 Server Ent Ed. SP 1 , and the ODBC driver version is 2000.86.1830.00

 

I hope some one outthere has any ideas to solve this problem, or at least any idea of what is causing this error, because i´m running out of them.

 

Thanks in advance.

 

Efrain Morales

View Replies View Related

Bcp Cannot Connect Via Local Connection, But Can Using Remote Connection?

Hi. I'm (very) new to SQL Server. I have run into what seems to be a very common problem, judging by the number of Google hits, but it's not actually in the FAQs here, as far as I can see.

Situation
I installed SQL Server Express with Advanced Services 2005 on my Windows XP Pro laptop, using (with one exception) the default install. The exception was to put the data files on a separate partition (D: ) where I have more free space.

SQL Server Management Studio Express connects happily, and I set up a single data import table.

Issue: bcp Fails to connect to default local instance
I initially tried bcp in output mode, prior to working in earnest on importing my data. However the command line-


bcp MyDatabaseName.dbo.UserProfile out UserProfile.txt -T -c

Fails with the error-


Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].

As I understand it, the local instance of SSE is the default, and should use a local (shared memory?) connection. This seems to work for Management Studion Express, but not bcp.


While investigating this problem, I tried enabling remote connections (all types) through the Surface Area Configuration wizard, and found that remote connections using either of:


bcp eSpacePh1.dbo.UserProfile out UserProfile.txt -T -c -S localhostsqlexpress
bcp eSpacePh1.dbo.UserProfile out UserProfile.txt -T -c -S mycomputernamesqlexpress

both work ok.

Extra Info
When starting Management Studio Express, it says something like "Configuring environment for the first time". However it says this every time it is started, not just the first run after installation, does this indicate some configuration data is not being successfully stored?

I have found threads that look similar to my issue-


http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=836670&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3351349&SiteID=1

However these do not relate directly to bcp, and to be honest my knowledge of SSE is slender enough at this stage that i'm unsure if there are really relevant.

Any hints on how to proceed much appreciated.

Regards: Colin E.

View Replies View Related

"ODBC--Call Failed" And "ODBC--connection To 'SQLServerMYSERVER' Failed"

We are using Access as a front end to a DB we house on a SQL 2000 SP2 box. I have 2 users utilizing this front end and they keep recieving these two errors
"ODBC--Call Failed" and "ODBC--connection to 'SQLServerMYSERVER' failed"
when trying to run a query window. They get the called failed message 99% of the time. I on the other hand, have no problems doing any of this without a File DSN defined. I verified all the file permissions to rule that out. And I also verified how their permissions were setup in Enterprise Manager and they are set the same as mine. The other users get the errors with or without the File DSN defined. After relinking the tables in the front end, it seems to go away for awhile, but then reappears. The only other way I could get the errors to disappear was to make them a domain admin like myself. When I did that, everything seemed to work fine. Now obviously I can't leave them like that, so I was hoping someone would be able to kindly point me in the right direction on how to resolve this. Please help, I am completely out of ideas here. Thanks in advance. Mike

View Replies View Related

ODBC Connect Times Out, But 2nd Time Works

When I begin Enterprise Manager and open a connection to a Server, it fails with a timeout error. But if I do a refresh and then connect again, it immediately works.
I have had similar symptoms setting up a data source for ODBC. When you initially logon to SQL Server to define the connection it times out. But then if you immediately try again it succeeds.
Furthermore one of my application programs fails to work (due to the timeout) on systems that have this behavior.
I have had these symptoms occur on 2 diferent workstations, but other workstations access the SQL Server with no problem.
All systems are WinNT 4.0; the engine is SQL Server 7 with SP2. The timeout is defined as 15 seconds so should be long enough.

Does anyone know what is going on, or how to fix it?

View Replies View Related

Runtime Connect Error To ODBC System DSN

Hello,

I have created an SSIS package to retrieve data from a Lotus Notes database using the NotesSQL 3.02g ODBC driver.

In SSIS design mode, I can connect to the Notes datasource using the following connection string without any validation errors.

uid=UserID;Dsn=LN_Costs;

I have tried other variations of the connection string including every possible connection string parameter available to the driver as follows.

server=Server_Name;uid=UserID;Dsn=DSN_Name;Driver={Lotus NotesSQL Driver (*.nsf)};database=costing/productcost.nsf;username=UserID;encryptpwd=encrypted_password;maxsubquery=20;maxstmtlen=4096;maxrels=20;maxvarcharlen=254;keeptempidx=1;maxlongvarcharlen=512;showimplicitflds=0;mapspecialchars=1;threadtimeout=60;

Using the above connection strings in SSIS design mode, the datasource test succeeds, and an sql select statement in a datasource reader returns the table structure with no error.

However, when I try to run the package, I receive the following error.

SSIS package "Sales Data Load.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0047062 at Data Flow Task, DataReader Source 2 [408]: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
   at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
   at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)
Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "DataReader Source 2" (408) failed validation and returned error code 0x80131937.
Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Sales Data Load.dtsx" finished: Failure.

Furthermore, I have packages configured in SQL 2000 DTS to use the same system dsn without any errors.

Why doesn't this work in SQL 2005 SSIS?

Thanks.

View Replies View Related

Runtime Connect Error To ODBC System DSN

Hello,

I have created an SSIS package to retrieve data from a Lotus Notes database using the NotesSQL 3.02g ODBC driver.

In SSIS design mode, I can connect to the Notes datasource using the following connection string without any validation errors.

uid=UserID;Dsn=LN_Costs;

I have tried other variations of the connection string including every possible connection string parameter available to the driver as follows.

server=Server_Name;uid=UserID;Dsn=DSN_Name;Driver={Lotus NotesSQL Driver (*.nsf)};database=costing/productcost.nsf;username=UserID;encryptpwd=encrypted_password;maxsubquery=20;maxstmtlen=4096;maxrels=20;maxvarcharlen=254;keeptempidx=1;maxlongvarcharlen=512;showimplicitflds=0;mapspecialchars=1;threadtimeout=60;

Using the above connection strings in SSIS design mode, the datasource test succeeds, and an sql select statement in a datasource reader returns the table structure with no error.

However, when I try to run the package, I receive the following error.

SSIS package "Sales Data Load.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0047062 at Data Flow Task, DataReader Source 2 [408]: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
   at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
   at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)
Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "DataReader Source 2" (408) failed validation and returned error code 0x80131937.
Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Sales Data Load.dtsx" finished: Failure.

Furthermore, I have packages configured in SQL 2000 DTS to use the same system dsn without any errors.

Why doesn't this work in SQL 2005 SSIS?

Thanks.

View Replies View Related

Cannot Connect To SQL 2005 Using Vista ODBC Administrator

Here's the context:
 
Database server:
 - Remote machine running SQL 2005 Standard as a named instance
 - Named pipes and TCP are enabled for remote connections
 - SQLBrowser service is running
 - Listening on default named pipe (\servernamepipeMSSQL$instancenamesqlquery)
 
Client:
 - Vista Business machine
 - Not in same domain as server, but on the same network (via Cisco VPN)
 - SQL 2005 Express is installed (for use with local databases)
 - Windows Firewall enabled
 - Running Symantec Antivirus, Corporate Edition
 
Connectivity:
 - I CAN connect to SQL 2005 databases on the remote server using  "nperverinstancename"
 - I CAN connect to SQL 2005 databases on the remote server using Excel 2007
 
The problem is that I cannot successfully create an ODBC datasource using the "ODBC Data Source Administrator" application.  I'm using the "SQL Server" driver and trying to create a System DSN.  I'm also running the tool with elevated permissions.
 
 - When I try to use "servernameinstancename" as the server and TCP as the connection type, I get this error:

Connection failed: SQL Server Error: 18452; "[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user ''.  The user is not associated with a trusted SQL Server connection.
 
 - When I try to use "npervernameinstancename" as the server and Named Pipes, I get this error:

Connection failed: SQLState: '01000'; SQL Server Error: 1326; [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
Connection failed: SQLState: '08000'; SQL Server Error: 17; [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Help!  I've really been beating my head against the wall on this one.  It all works just fine with a Windows XP client machine.

View Replies View Related

Can't Connect To The ODBC Database Named Aspol54

can any one provide any suggestions to help this error i installed automation studion 5.4 and the program will not run on my laptop.

i traced the data below when i try to start the program.

AsProjet        db0-b5c    ENTER SQLAllocEnv
        HENV *              015CF6B0

AsProjet        db0-b5c    EXIT  SQLAllocEnv  with return code 0 (SQL_SUCCESS)
        HENV *              0x015CF6B0 ( 0x015e1540)

AsProjet        db0-b5c    ENTER SQLGetEnvAttr
        SQLHENV             015E1540
        SQLINTEGER                 201 <unknown>
        SQLPOINTER          [Unknown attribute 201]
        SQLINTEGER                   4
        SQLINTEGER *        0x0013E380

AsProjet        db0-b5c    EXIT  SQLGetEnvAttr  with return code 0 (SQL_SUCCESS)
        SQLHENV             015E1540
        SQLINTEGER                 201 <unknown>
        SQLPOINTER          [Unknown attribute 201]
        SQLINTEGER                   4
        SQLINTEGER *        0x0013E380 (1567744)
any help would be great.

tks

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved