ODBC General Network Error - how to trace

[1DMF]

Hi,

I'm starting to get a lot of members complaining they are receiving the following error...

DBI connect('FILEDSN=my_file_.dsn;Regional=No;','myDB',...) failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation. (SQL-08001) [err was 1 now 1] [state was 08001 now 01000][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (PreLoginHandshake()). (SQL-01000) [err was 1 now 1] [state was 01000 now 01S00][Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (SQL-01S00) at

I've tried the perl forum as that is the where the DB connection originates from, but so far we have not been able to find a solution, and I'm wondering if this is more a SQL issue than a perl one.

Here is that thread for reference thread219-1601454

Can anyone suggest what might be causing this error, any potential solutions or how I go about tracing the problem to find the cause.

Many thanks,
1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[Crowley16]

the error says you're using a FileDSN, can you not directly connect to the server using Pearl? I've not programed in Pearl so don't know if it can do this or not.

have you checked the filedsn works, or maybe try a systemdsn?

--------------------
Procrastinate Now!

 

[1DMF]

It has nothing to do with my FileDSN, that is working fine.

The only reason it's even in the error message is because of the stupid DBI module thinks it's a good idea to give half the connection string away when it baulks.




"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[Crowley16]

you could run a profiler trace on your sql server and check for the security/login stuff, should give you some idea there or at least show you if the connection attempt is getting to the server or not...

--------------------
Procrastinate Now!

 

[1DMF]

Can you help with the settings?

I;ve created a profiler trace and I've added a filter to only show ApplicationName "ActivePerl", but it is still showing SQLAgent entries?

There are rather alot of events to choose from it's a bit overwhelming for a newbie to know what to select and how to configure the trace correctly.

cheers,
1DMF



"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[Crowley16]

you can use the not like application name filters to filter out stuff you're not interested in. below the filters, there's a little tick box which says exclude rows with no data, it may help to tick that...
Generally, I don't use the like app name filters since it's too easy to exclude stuff which you want. If I'm not familiar with a server, I let the trace run for a bit, and then based on the results, add in extra not like filters to filter stuff out that I don't want.

as for the events, just pick the standard trace template, that has enough for what you want. you can remove the stored procedures and tsql ones if you want, you probably don't need the audit logout either, but you never know...

also, I'd usually pick show all columns since you never know which columns may be useful. you can toggle the main tick box to make it pick up all columns if it's greyed...

hope that all makes sense...

--------------------
Procrastinate Now!

 

[1DMF]

Typical, I started the trace , and went home.

We had a member last night have the problem I'm trying to track, only the trace log is 3kb and last modified at 17:16.

Which means when i killed my RDP session to the server it killed the trace as well.

So I'll have to start it again tonight, direct from the main server console.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts