ODBC Connection Problems

[Trudye]

I'm not sure if this is the right forum if not pls let me know which forum I should address.

I am having problems setting up my ODBC connection between my SQL Server and my Database. I received two errors when I selected With Windows NT option on the DSN configuration screen, they are:
53 - Microsoft ODBC SQL Server Driver [DBNETLIB}ConnectionOpen (Connect();
17 - Microsoft ODBC SQL Server Driver [DBNETLIB} does not exist or access is denied.

When I selected with SQL Server I received the following errors;
2 - Microsoft ODBC SQL Server Driver [Shared memory}ConnectionOpen (Connect();

I tried to connect by using the System DSN tab in ODBC Admin.; highlighting the (Local Server} SQL Server that was listed there and clicking Configure.

When I was asked to enter the Server Name and server I took the defaults of: [Local Server] and Local.

Is there a step that I am missing?

Thank you so much,
Trudye

 

[darrellblackhawk]

This may sound silly, but do you have a SQL Sever instance running?

Darrell

 

[Trudye]

Since this is the first time I installed SQL Server nothing sounds silly. But yes I do have an instancde running.

Thanks
Trudye

 

[SonOfEmidec1100]

Two thoughts

Is the network library used by the DSN client connection an enabled protocol on sqlserver.

When referencing the server as local it must be in brackets ie (local)

 

[Trudye]

Thanks guys I found out (not figured out but was informaed) that I needed to Create the database pointing to a .BAK file. Once I did that I was able to setup my ODBC.

Thank so much for your help I am sure I will have other questions in the very near future.

Be well,
Trudye

 

[Trudye]

Silly me I thought I had the problem solved, goes to show you how much I know.

Although I can see my tables in Enterprise Mngr I am still having Connection problems. I am now getting two different errors:

Run Time error -2147209200 (80043010)
Failed to open registry becasue an invalid key name was specified.

run time error '3151'
ODBC Connection to TDP2k failed
I couldn't find anything in FAQ for the first error and none for SQL regarading the second question.

Any ideas? Any one?
Thanks
Trudye

 

[SonOfEmidec1100]

Are you creating the DSN through the DataSource(ODBC) administrator? If so does the test button give you an OK response. If you are creating the DSN thru code maybe try using the DSN administrator.

Have you installed latest service packs for sql server and the o/s.

 

[Trudye]

I have discovred that the ServerClientLocation resides on a table, but I do not know what the value/path should be. This is unique to this Server environment. I have a call into the developer but he is very busy and I have no idea when he will be able to get back to me.

But I do have another question. Isn't it possible for Enterprise Manager to set up everything for you? I have another database I developed using MS Access 2k. Can I replace this instance or do I have to delete this instance and create a new one?

That might work better for me. Since I'm just learning SQL Server and T-SQL.

Thanks for all your help
Trudye

 

[SonOfEmidec1100]

Ive found you can do almost everything you need with EM.

If you want to convert/load an access database into sql server use EM right click Databases and select all tasks/import data then follow the wizard.

Im not exactly sure what you asking in regards to 'replacing this instance'. In basic sql server environments you only have one instance (although it is possible to have multiple named instances). Within each instance you have multiple databases, when you first install sql server there are 6 system databases created 9eg master and tempdb). With EM or T-SQL you can create or delete your own databases as needed.

If this does not answer you question I would suggest starting a new thread as it is no longer about ODBC.

 

[Trudye]

Thank you so much you not only answered my question but it made perfect sense. Of course you can delete a database from SQL Server (DUH!).

I will delete the current database and sue EM to add my new database.

Congrats to you for deciphering my cryptic message. The rambling of a novice are sometimes difficult to understand.


Be well,
Trudye